/*
 Navicat Premium Data Transfer

 Source Server         : 119.27.170.117
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : 119.27.170.117:3306
 Source Schema         : sports

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 07/08/2020 16:54:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for card
-- ----------------------------
DROP TABLE IF EXISTS `card`;
CREATE TABLE `card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '操作人员id',
  `card_type` tinyint(4) NOT NULL COMMENT '会员卡类型,1储值卡 2次卡 3期限卡',
  `card_name` varchar(100) NOT NULL COMMENT '会员卡名称',
  `card_discount` float(4,2) NOT NULL COMMENT '会员卡可享受折扣，小数形式',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '会员卡金额，type=1 时必填',
  `price` int(11) NOT NULL COMMENT '售价',
  `image` varchar(255) NOT NULL DEFAULT '' COMMENT '会员卡图片',
  `interests` text NOT NULL COMMENT '权益',
  `Instructions` text NOT NULL COMMENT '使用须知',
  `effective_time` int(11) NOT NULL DEFAULT '0' COMMENT '有效时间，单位：天，0 为永久，type=3必填 ',
  `use_count` int(11) NOT NULL DEFAULT '0' COMMENT '使用总次数，type=2 时必填',
  `use_stadium_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '可消费场馆id',
  `use_project_ids` varchar(255) NOT NULL DEFAULT '' COMMENT '可消费项目id',
  `active_mode` tinyint(4) NOT NULL COMMENT '激活方式，1办卡即开，2第一次使用',
  `advance_booking_days` smallint(6) NOT NULL COMMENT '可提前订场天数，单位天，0为不限制',
  `cancel_booking_days` smallint(6) NOT NULL COMMENT '可提前取消订场天数，单位天，0为不限制',
  `same_time_places` smallint(6) NOT NULL COMMENT '同一时间可订场数量，0为不限制',
  `day_max_times` float(10,2) NOT NULL COMMENT '单日最多订场时间， 单位小时，0不限制',
  `week_max_times` float(10,2) NOT NULL COMMENT '每周最多订场时间， 单位小时，0不限制',
  `note` text NOT NULL COMMENT '备注',
  `status` tinyint(4) NOT NULL COMMENT '状态，1正常售卖，2停止售卖',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员卡类型信息表';

-- ----------------------------
-- Table structure for facilities
-- ----------------------------
DROP TABLE IF EXISTS `facilities`;
CREATE TABLE `facilities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL COMMENT '设施',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场馆设施表';

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `mid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '操作人员id',
  `nickname` varchar(100) NOT NULL COMMENT '昵称',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `phone` varchar(100) NOT NULL DEFAULT '' COMMENT '手机号',
  `bothday` char(10) NOT NULL DEFAULT '' COMMENT '生日',
  `id_number` char(18) NOT NULL DEFAULT '' COMMENT '身份证号码',
  `address` varchar(500) NOT NULL DEFAULT '' COMMENT '地址',
  `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别 1男 2女 0未知',
  `avatar` varchar(500) NOT NULL DEFAULT '' COMMENT '头像地址',
  `stadium_id` int(11) NOT NULL COMMENT '场管id',
  `adviser` varchar(100) NOT NULL DEFAULT '' COMMENT '会籍顾问',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否启用 1启用 2禁用',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for member_card
-- ----------------------------
DROP TABLE IF EXISTS `member_card`;
CREATE TABLE `member_card` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '操作人员id',
  `mid` int(11) NOT NULL COMMENT '用户id',
  `card_sn` varchar(20) NOT NULL COMMENT '会员卡编号',
  `card_id` int(11) NOT NULL COMMENT '会员卡id',
  `card_type` tinyint(4) NOT NULL COMMENT '会员卡类型,1储值卡 2次卡 3期限卡',
  `card_name` varchar(100) NOT NULL COMMENT '会员卡名称',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '会员卡剩余总金额',
  `use_count` int(11) NOT NULL COMMENT '会员卡剩余总次数',
  `expire_time` int(11) NOT NULL DEFAULT '0' COMMENT '会员卡过期时间，0为永久',
  `first_use_time` int(11) NOT NULL DEFAULT '0' COMMENT '第一次使用时间',
  `status` tinyint(4) NOT NULL COMMENT '状态，1正常，2冻结，3停卡',
  `note` text NOT NULL COMMENT '备注',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_sn` (`card_sn`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户会员卡信息';

-- ----------------------------
-- Table structure for member_card_log
-- ----------------------------
DROP TABLE IF EXISTS `member_card_log`;
CREATE TABLE `member_card_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '操作管理员id，会员自己操作时没有值',
  `mid` int(11) NOT NULL COMMENT '会员预定',
  `ms_card_sn` varchar(20) NOT NULL COMMENT '会员卡编号',
  `order_sn` varchar(20) NOT NULL COMMENT '订单编号',
  `use_type` tinyint(4) NOT NULL COMMENT '使用类型 1扣款，2充值',
  `before_amount` int(11) NOT NULL COMMENT '使用前余额,储值卡为金额，次卡为次数',
  `use_amount` int(11) NOT NULL COMMENT '使用余额,储值卡为金额，次卡为次数',
  `current_amount` int(11) NOT NULL COMMENT '使用后余额,储值卡为金额，次卡为次数',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员卡使用记录';

-- ----------------------------
-- Table structure for member_card_order
-- ----------------------------
DROP TABLE IF EXISTS `member_card_order`;
CREATE TABLE `member_card_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '预定操作人，后台人员操作时有值',
  `mid` int(11) NOT NULL DEFAULT '0' COMMENT '会员预定，会员自己预定时有值',
  `order_sn` varchar(20) NOT NULL COMMENT '订单编号',
  `card_sn` varchar(20) NOT NULL COMMENT '会员卡编号',
  `card_type` tinyint(4) NOT NULL COMMENT '会员卡类型,1储值卡 2次卡 3期限卡',
  `use_time` int(11) NOT NULL DEFAULT '0' COMMENT '购买的有效时间，单位：天，0 为永久，type=3必填 ',
  `use_count` int(11) NOT NULL DEFAULT '0' COMMENT '购买的次数，type=2 时必填',
  `use_amount` int(11) NOT NULL DEFAULT '0' COMMENT '购买的金额，type=1 时必填',
  `stadium_id` int(11) NOT NULL COMMENT '场馆id',
  `order_type` tinyint(4) NOT NULL COMMENT '订单类型，1新购 2续费充值',
  `amount` int(11) NOT NULL COMMENT '订单总金额',
  `pay_amount` int(11) NOT NULL COMMENT '订单实际支付金额',
  `pay_type` tinyint(4) NOT NULL COMMENT '支付类型，1现金支付 ，3支付宝支付，4微信支付,5其他',
  `status` tinyint(4) NOT NULL COMMENT '订单装态，1支付成功，2等待支付，3已退款，4部分退款',
  `note` text NOT NULL COMMENT '备注',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场地订单信息表';

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '预定操作人，后台人员操作时有值',
  `mid` int(11) NOT NULL DEFAULT '0' COMMENT '会员预定，会员自己预定时有值',
  `order_sn` varchar(20) NOT NULL COMMENT '订单编号',
  `order_type` tinyint(4) NOT NULL COMMENT '订单类型 1购买场地，2购买会员卡，3会员卡充值',
  `amount` float(10,2) NOT NULL COMMENT '订单金额',
  `pay_amount` float(10,2) NOT NULL COMMENT '订单实际支付金额',
  `pay_type` tinyint(4) NOT NULL COMMENT '支付类型，1现金支付 2会员卡支付，3支付宝支付，4微信支付',
  `pay_time` int(11) NOT NULL COMMENT '支付时间',
  `pay_status` tinyint(4) NOT NULL COMMENT '支付状态，1完成支付 2等待支付 3已退款',
  `note` text NOT NULL COMMENT '备注',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单信息表';

-- ----------------------------
-- Table structure for place
-- ----------------------------
DROP TABLE IF EXISTS `place`;
CREATE TABLE `place` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '创建人id',
  `place_name` varchar(100) NOT NULL COMMENT '场地名称',
  `stadium_id` int(11) NOT NULL COMMENT '场管关联id',
  `projcet_id` int(11) NOT NULL COMMENT '项目关联id',
  `project_name` varchar(100) DEFAULT NULL COMMENT '冗余项目名称',
  `status` tinyint(4) NOT NULL COMMENT '状态。1，对内可见、2，仅会员可见、3.仅非会员可见、4.全部可见、5全部不可见',
  `start_times` float(8,2) NOT NULL COMMENT '至少起订时间，单位小时',
  `limit_times` float(8,2) NOT NULL COMMENT '起订时间加时幅度，单位小时',
  `price` int(11) NOT NULL COMMENT '每小时价格，单价(分)',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场地信息表';

-- ----------------------------
-- Table structure for place_order
-- ----------------------------
DROP TABLE IF EXISTS `place_order`;
CREATE TABLE `place_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '预定操作人，后台人员操作时有值',
  `mid` int(11) NOT NULL DEFAULT '0' COMMENT '会员预定，会员自己预定时有值',
  `order_sn` varchar(20) NOT NULL COMMENT '订单编号',
  `place_id` int(11) NOT NULL COMMENT '场地id',
  `stadium_id` int(11) NOT NULL COMMENT '场馆id',
  `order_type` tinyint(4) NOT NULL COMMENT '订单类型，1会员 2散客，3预留',
  `amount` int(11) NOT NULL COMMENT '订单总金额',
  `pay_amount` int(11) NOT NULL COMMENT '订单实际支付金额',
  `pay_type` tinyint(4) NOT NULL COMMENT '支付类型，1现金支付 2会员卡支付，3支付宝支付，4微信支付',
  `card_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '仅pay_type=2时存在，会员卡类型,1储值卡 2次卡 3期限卡',
  `status` tinyint(4) NOT NULL COMMENT '订单装态，1支付成功，2等待支付，3已退款，4部分退款',
  `note` text NOT NULL COMMENT '备注',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场地订单信息表';

-- ----------------------------
-- Table structure for place_order_detail
-- ----------------------------
DROP TABLE IF EXISTS `place_order_detail`;
CREATE TABLE `place_order_detail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mid` int(11) NOT NULL DEFAULT '0' COMMENT '会员预定，会员自己预定时有值',
  `order_sn` varchar(20) NOT NULL COMMENT '订单编号',
  `place_id` int(11) NOT NULL COMMENT '场地id',
  `stadium_id` int(11) NOT NULL COMMENT '场馆id',
  `project_id` int(11) NOT NULL COMMENT '项目id',
  `date` varchar(10) NOT NULL DEFAULT '' COMMENT '预定日期',
  `place_times_ids` varchar(100) NOT NULL COMMENT '预定的时间颗粒',
  `start_time` int(11) NOT NULL COMMENT '开始时间',
  `end_time` int(11) NOT NULL COMMENT '结束时间',
  `time_count` float(10,2) NOT NULL COMMENT '总时间 单位小时',
  `amount` int(11) NOT NULL COMMENT '总金额',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订场详细信息表';

-- ----------------------------
-- Table structure for place_price
-- ----------------------------
DROP TABLE IF EXISTS `place_price`;
CREATE TABLE `place_price` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '操作人员id',
  `place_times_id` int(11) NOT NULL COMMENT '时间类型id',
  `place_id` int(11) NOT NULL COMMENT '场地id',
  `stadium_id` int(11) NOT NULL COMMENT '场馆id',
  `vip_level` tinyint(4) NOT NULL COMMENT 'vip等级',
  `price` float(8,2) NOT NULL COMMENT '价格 元/小时',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否启用 1启用 2禁用',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场地单位时间价格表';

-- ----------------------------
-- Table structure for place_reserve
-- ----------------------------
DROP TABLE IF EXISTS `place_reserve`;
CREATE TABLE `place_reserve` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '预定操作人，后台人员操作时有值',
  `mid` int(11) NOT NULL DEFAULT '0' COMMENT '会员预定，会员自己预定时有值',
  `stadium_id` int(11) NOT NULL COMMENT '场馆id',
  `place_id` int(11) NOT NULL COMMENT '场地id',
  `place_times_id` int(11) NOT NULL COMMENT '时间颗粒id',
  `reserve_type` int(11) NOT NULL COMMENT '预定类型，1会员预定，2散客预定，3系统预留',
  `is_long` tinyint(4) NOT NULL DEFAULT '2' COMMENT '是否长期订单，1是，2否',
  `use_date` char(10) NOT NULL COMMENT '预定使用日期',
  `use_time_start` char(8) NOT NULL COMMENT '预定使用开始时间',
  `use_time_end` char(8) NOT NULL COMMENT '预定使用结束时间',
  `use_times` float(8,2) NOT NULL COMMENT '使用时长',
  `reserve_status` tinyint(4) NOT NULL COMMENT '预定状态，1有效，2无效',
  `note` text NOT NULL COMMENT '备注',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='预定场地信息表';

-- ----------------------------
-- Table structure for place_times
-- ----------------------------
DROP TABLE IF EXISTS `place_times`;
CREATE TABLE `place_times` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `week` tinyint(4) NOT NULL COMMENT '周， 1，2，3，4，5，6，7',
  `time_start` char(5) NOT NULL COMMENT '开始时间 比如 08:00',
  `time_end` char(5) NOT NULL COMMENT '结束时间 如09:00',
  `time_count` float(6,2) NOT NULL DEFAULT '0.50' COMMENT '时间长度',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=337 DEFAULT CHARSET=utf8mb4 COMMENT='订购场地时间粒度表';

-- ----------------------------
-- Records of place_times
-- ----------------------------
BEGIN;
INSERT INTO `place_times` VALUES (1, 1, '00:00', '00:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (2, 1, '00:30', '01:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (3, 1, '01:00', '01:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (4, 1, '01:30', '02:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (5, 1, '02:00', '02:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (6, 1, '02:30', '03:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (7, 1, '03:00', '03:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (8, 1, '03:30', '04:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (9, 1, '04:00', '04:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (10, 1, '04:30', '05:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (11, 1, '05:00', '05:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (12, 1, '05:30', '06:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (13, 1, '06:00', '06:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (14, 1, '06:30', '07:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (15, 1, '07:00', '07:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (16, 1, '07:30', '08:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (17, 1, '08:00', '08:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (18, 1, '08:30', '09:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (19, 1, '09:00', '09:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (20, 1, '09:30', '10:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (21, 1, '10:00', '10:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (22, 1, '10:30', '11:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (23, 1, '11:00', '11:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (24, 1, '11:30', '12:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (25, 1, '12:00', '12:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (26, 1, '12:30', '13:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (27, 1, '13:00', '13:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (28, 1, '13:30', '14:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (29, 1, '14:00', '14:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (30, 1, '14:30', '15:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (31, 1, '15:00', '15:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (32, 1, '15:30', '16:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (33, 1, '16:00', '16:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (34, 1, '16:30', '17:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (35, 1, '17:00', '17:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (36, 1, '17:30', '18:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (37, 1, '18:00', '18:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (38, 1, '18:30', '19:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (39, 1, '19:00', '19:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (40, 1, '19:30', '20:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (41, 1, '20:00', '20:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (42, 1, '20:30', '21:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (43, 1, '21:00', '21:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (44, 1, '21:30', '22:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (45, 1, '22:00', '22:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (46, 1, '22:30', '23:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (47, 1, '23:00', '23:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (48, 1, '23:30', '00:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (49, 2, '00:00', '00:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (50, 2, '00:30', '01:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (51, 2, '01:00', '01:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (52, 2, '01:30', '02:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (53, 2, '02:00', '02:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (54, 2, '02:30', '03:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (55, 2, '03:00', '03:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (56, 2, '03:30', '04:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (57, 2, '04:00', '04:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (58, 2, '04:30', '05:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (59, 2, '05:00', '05:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (60, 2, '05:30', '06:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (61, 2, '06:00', '06:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (62, 2, '06:30', '07:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (63, 2, '07:00', '07:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (64, 2, '07:30', '08:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (65, 2, '08:00', '08:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (66, 2, '08:30', '09:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (67, 2, '09:00', '09:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (68, 2, '09:30', '10:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (69, 2, '10:00', '10:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (70, 2, '10:30', '11:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (71, 2, '11:00', '11:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (72, 2, '11:30', '12:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (73, 2, '12:00', '12:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (74, 2, '12:30', '13:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (75, 2, '13:00', '13:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (76, 2, '13:30', '14:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (77, 2, '14:00', '14:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (78, 2, '14:30', '15:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (79, 2, '15:00', '15:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (80, 2, '15:30', '16:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (81, 2, '16:00', '16:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (82, 2, '16:30', '17:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (83, 2, '17:00', '17:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (84, 2, '17:30', '18:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (85, 2, '18:00', '18:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (86, 2, '18:30', '19:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (87, 2, '19:00', '19:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (88, 2, '19:30', '20:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (89, 2, '20:00', '20:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (90, 2, '20:30', '21:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (91, 2, '21:00', '21:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (92, 2, '21:30', '22:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (93, 2, '22:00', '22:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (94, 2, '22:30', '23:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (95, 2, '23:00', '23:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (96, 2, '23:30', '00:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (97, 3, '00:00', '00:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (98, 3, '00:30', '01:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (99, 3, '01:00', '01:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (100, 3, '01:30', '02:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (101, 3, '02:00', '02:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (102, 3, '02:30', '03:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (103, 3, '03:00', '03:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (104, 3, '03:30', '04:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (105, 3, '04:00', '04:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (106, 3, '04:30', '05:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (107, 3, '05:00', '05:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (108, 3, '05:30', '06:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (109, 3, '06:00', '06:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (110, 3, '06:30', '07:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (111, 3, '07:00', '07:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (112, 3, '07:30', '08:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (113, 3, '08:00', '08:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (114, 3, '08:30', '09:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (115, 3, '09:00', '09:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (116, 3, '09:30', '10:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (117, 3, '10:00', '10:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (118, 3, '10:30', '11:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (119, 3, '11:00', '11:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (120, 3, '11:30', '12:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (121, 3, '12:00', '12:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (122, 3, '12:30', '13:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (123, 3, '13:00', '13:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (124, 3, '13:30', '14:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (125, 3, '14:00', '14:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (126, 3, '14:30', '15:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (127, 3, '15:00', '15:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (128, 3, '15:30', '16:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (129, 3, '16:00', '16:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (130, 3, '16:30', '17:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (131, 3, '17:00', '17:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (132, 3, '17:30', '18:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (133, 3, '18:00', '18:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (134, 3, '18:30', '19:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (135, 3, '19:00', '19:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (136, 3, '19:30', '20:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (137, 3, '20:00', '20:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (138, 3, '20:30', '21:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (139, 3, '21:00', '21:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (140, 3, '21:30', '22:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (141, 3, '22:00', '22:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (142, 3, '22:30', '23:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (143, 3, '23:00', '23:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (144, 3, '23:30', '00:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (145, 4, '00:00', '00:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (146, 4, '00:30', '01:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (147, 4, '01:00', '01:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (148, 4, '01:30', '02:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (149, 4, '02:00', '02:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (150, 4, '02:30', '03:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (151, 4, '03:00', '03:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (152, 4, '03:30', '04:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (153, 4, '04:00', '04:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (154, 4, '04:30', '05:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (155, 4, '05:00', '05:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (156, 4, '05:30', '06:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (157, 4, '06:00', '06:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (158, 4, '06:30', '07:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (159, 4, '07:00', '07:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (160, 4, '07:30', '08:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (161, 4, '08:00', '08:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (162, 4, '08:30', '09:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (163, 4, '09:00', '09:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (164, 4, '09:30', '10:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (165, 4, '10:00', '10:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (166, 4, '10:30', '11:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (167, 4, '11:00', '11:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (168, 4, '11:30', '12:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (169, 4, '12:00', '12:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (170, 4, '12:30', '13:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (171, 4, '13:00', '13:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (172, 4, '13:30', '14:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (173, 4, '14:00', '14:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (174, 4, '14:30', '15:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (175, 4, '15:00', '15:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (176, 4, '15:30', '16:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (177, 4, '16:00', '16:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (178, 4, '16:30', '17:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (179, 4, '17:00', '17:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (180, 4, '17:30', '18:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (181, 4, '18:00', '18:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (182, 4, '18:30', '19:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (183, 4, '19:00', '19:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (184, 4, '19:30', '20:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (185, 4, '20:00', '20:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (186, 4, '20:30', '21:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (187, 4, '21:00', '21:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (188, 4, '21:30', '22:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (189, 4, '22:00', '22:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (190, 4, '22:30', '23:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (191, 4, '23:00', '23:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (192, 4, '23:30', '00:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (193, 5, '00:00', '00:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (194, 5, '00:30', '01:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (195, 5, '01:00', '01:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (196, 5, '01:30', '02:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (197, 5, '02:00', '02:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (198, 5, '02:30', '03:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (199, 5, '03:00', '03:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (200, 5, '03:30', '04:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (201, 5, '04:00', '04:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (202, 5, '04:30', '05:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (203, 5, '05:00', '05:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (204, 5, '05:30', '06:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (205, 5, '06:00', '06:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (206, 5, '06:30', '07:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (207, 5, '07:00', '07:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (208, 5, '07:30', '08:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (209, 5, '08:00', '08:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (210, 5, '08:30', '09:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (211, 5, '09:00', '09:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (212, 5, '09:30', '10:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (213, 5, '10:00', '10:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (214, 5, '10:30', '11:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (215, 5, '11:00', '11:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (216, 5, '11:30', '12:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (217, 5, '12:00', '12:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (218, 5, '12:30', '13:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (219, 5, '13:00', '13:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (220, 5, '13:30', '14:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (221, 5, '14:00', '14:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (222, 5, '14:30', '15:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (223, 5, '15:00', '15:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (224, 5, '15:30', '16:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (225, 5, '16:00', '16:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (226, 5, '16:30', '17:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (227, 5, '17:00', '17:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (228, 5, '17:30', '18:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (229, 5, '18:00', '18:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (230, 5, '18:30', '19:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (231, 5, '19:00', '19:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (232, 5, '19:30', '20:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (233, 5, '20:00', '20:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (234, 5, '20:30', '21:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (235, 5, '21:00', '21:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (236, 5, '21:30', '22:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (237, 5, '22:00', '22:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (238, 5, '22:30', '23:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (239, 5, '23:00', '23:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (240, 5, '23:30', '00:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (241, 6, '00:00', '00:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (242, 6, '00:30', '01:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (243, 6, '01:00', '01:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (244, 6, '01:30', '02:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (245, 6, '02:00', '02:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (246, 6, '02:30', '03:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (247, 6, '03:00', '03:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (248, 6, '03:30', '04:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (249, 6, '04:00', '04:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (250, 6, '04:30', '05:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (251, 6, '05:00', '05:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (252, 6, '05:30', '06:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (253, 6, '06:00', '06:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (254, 6, '06:30', '07:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (255, 6, '07:00', '07:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (256, 6, '07:30', '08:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (257, 6, '08:00', '08:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (258, 6, '08:30', '09:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (259, 6, '09:00', '09:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (260, 6, '09:30', '10:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (261, 6, '10:00', '10:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (262, 6, '10:30', '11:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (263, 6, '11:00', '11:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (264, 6, '11:30', '12:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (265, 6, '12:00', '12:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (266, 6, '12:30', '13:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (267, 6, '13:00', '13:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (268, 6, '13:30', '14:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (269, 6, '14:00', '14:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (270, 6, '14:30', '15:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (271, 6, '15:00', '15:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (272, 6, '15:30', '16:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (273, 6, '16:00', '16:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (274, 6, '16:30', '17:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (275, 6, '17:00', '17:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (276, 6, '17:30', '18:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (277, 6, '18:00', '18:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (278, 6, '18:30', '19:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (279, 6, '19:00', '19:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (280, 6, '19:30', '20:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (281, 6, '20:00', '20:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (282, 6, '20:30', '21:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (283, 6, '21:00', '21:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (284, 6, '21:30', '22:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (285, 6, '22:00', '22:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (286, 6, '22:30', '23:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (287, 6, '23:00', '23:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (288, 6, '23:30', '00:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (289, 7, '00:00', '00:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (290, 7, '00:30', '01:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (291, 7, '01:00', '01:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (292, 7, '01:30', '02:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (293, 7, '02:00', '02:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (294, 7, '02:30', '03:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (295, 7, '03:00', '03:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (296, 7, '03:30', '04:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (297, 7, '04:00', '04:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (298, 7, '04:30', '05:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (299, 7, '05:00', '05:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (300, 7, '05:30', '06:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (301, 7, '06:00', '06:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (302, 7, '06:30', '07:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (303, 7, '07:00', '07:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (304, 7, '07:30', '08:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (305, 7, '08:00', '08:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (306, 7, '08:30', '09:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (307, 7, '09:00', '09:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (308, 7, '09:30', '10:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (309, 7, '10:00', '10:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (310, 7, '10:30', '11:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (311, 7, '11:00', '11:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (312, 7, '11:30', '12:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (313, 7, '12:00', '12:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (314, 7, '12:30', '13:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (315, 7, '13:00', '13:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (316, 7, '13:30', '14:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (317, 7, '14:00', '14:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (318, 7, '14:30', '15:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (319, 7, '15:00', '15:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (320, 7, '15:30', '16:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (321, 7, '16:00', '16:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (322, 7, '16:30', '17:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (323, 7, '17:00', '17:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (324, 7, '17:30', '18:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (325, 7, '18:00', '18:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (326, 7, '18:30', '19:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (327, 7, '19:00', '19:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (328, 7, '19:30', '20:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (329, 7, '20:00', '20:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (330, 7, '20:30', '21:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (331, 7, '21:00', '21:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (332, 7, '21:30', '22:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (333, 7, '22:00', '22:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (334, 7, '22:30', '23:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (335, 7, '23:00', '23:30', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
INSERT INTO `place_times` VALUES (336, 7, '23:30', '00:00', 0.50, '2020-08-03 22:04:46', '2020-08-03 22:04:46');
COMMIT;

-- ----------------------------
-- Table structure for project
-- ----------------------------
DROP TABLE IF EXISTS `project`;
CREATE TABLE `project` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sport_name` varchar(100) NOT NULL COMMENT '项目名称',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场馆项目';

-- ----------------------------
-- Table structure for stadium
-- ----------------------------
DROP TABLE IF EXISTS `stadium`;
CREATE TABLE `stadium` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL COMMENT '添加用户',
  `stadium_name` varchar(100) NOT NULL COMMENT '场馆名称',
  `stadium_address` varchar(500) DEFAULT NULL COMMENT '场馆地址',
  `stadium_telephone` varchar(100) DEFAULT NULL COMMENT '场馆电话',
  `status` tinyint(4) DEFAULT NULL COMMENT '场馆状态 1正常，2停用',
  `business_start` char(8) DEFAULT NULL COMMENT '营业开始时间 如 12:11:00',
  `business_end` char(8) DEFAULT NULL COMMENT '营业结束时间 如 12:11:00',
  `bulletin` text COMMENT '场馆公告',
  `images` varchar(500) DEFAULT NULL COMMENT '场馆图片 图片地址数组 []',
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场馆信息表\r\n';

-- ----------------------------
-- Table structure for stadium_facilities
-- ----------------------------
DROP TABLE IF EXISTS `stadium_facilities`;
CREATE TABLE `stadium_facilities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stadium_id` int(11) NOT NULL,
  `facilities_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场馆设施关联表';

-- ----------------------------
-- Table structure for stadium_project
-- ----------------------------
DROP TABLE IF EXISTS `stadium_project`;
CREATE TABLE `stadium_project` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stadium_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='场馆项目关联表';

SET FOREIGN_KEY_CHECKS = 1;
